| Fully Qualified Name: | Laminas\Db\Sql\Platform\SqlServer\SelectDecorator |
| Extends: | Select |
| Implements: | PlatformDecoratorInterface |
| Name | Description | Defined By |
|---|---|---|
| __clone() | __clone | Select |
| __construct() | Constructor | Select |
| __get() | Variable overloading | Select |
| columns() | Specify columns from which to select | Select |
| combine() | Select | |
| from() | Create from clause | Select |
| getRawState() | Select | |
| getSqlString() | {@inheritDoc} | AbstractSql |
| group() | Select | |
| having() | Create having clause | Select |
| isTableReadOnly() | Returns whether the table is read only or not. | Select |
| join() | Create join clause | Select |
| limit() | Select | |
| offset() | Select | |
| order() | Select | |
| prepareStatement() | {@inheritDoc} | AbstractPreparableSql |
| quantifier() | Select | |
| reset() | Select | |
| setSpecification() | Select | |
| setSubject() | SelectDecorator | |
| where() | Create where clause | Select |
__clone
Resets the where object each time the Select is cloned.
Returns: void
Constructor
| Parameter Name | Type | Description |
|---|---|---|
| $table | null|string|array|\TableIdentifier |
Returns:
Variable overloading
| Parameter Name | Type | Description |
|---|---|---|
| $name | string |
Returns: mixed
Specify columns from which to select
Possible valid states:
array(*)
array(value, ...) value can be strings or Expression objects
array(string => value, ...) key string will be use as alias, value can be string or Expression objects
| Parameter Name | Type | Description |
|---|---|---|
| $columns | array | |
| $prefixColumnsWithTable | bool |
Returns: self Provides a fluent interface
| Parameter Name | Type | Description |
|---|---|---|
| $select | \Select | |
| $type | string | |
| $modifier | string |
Returns: self Provides a fluent interface
Create from clause
| Parameter Name | Type | Description |
|---|---|---|
| $table | string|array|\TableIdentifier |
Returns: self Provides a fluent interface
| Parameter Name | Type | Description |
|---|---|---|
| $key |
Returns: void
{@inheritDoc}
| Parameter Name | Type | Description |
|---|---|---|
| $adapterPlatform |
Returns:
| Parameter Name | Type | Description |
|---|---|---|
| $group | mixed |
Returns: self Provides a fluent interface
Create having clause
| Parameter Name | Type | Description |
|---|---|---|
| $predicate | \Where|\Closure|string|array | |
| $combination | string | One |
Returns: self Provides a fluent interface
Returns whether the table is read only or not.
Returns: bool
Create join clause
| Parameter Name | Type | Description |
|---|---|---|
| $name | string|array|\TableIdentifier | |
| $on | string|\Predicate\Expression | |
| $columns | string|array | |
| $type | string | one |
Returns: self Provides a fluent interface
| Parameter Name | Type | Description |
|---|---|---|
| $limit | int |
Returns: self Provides a fluent interface
| Parameter Name | Type | Description |
|---|---|---|
| $offset | int |
Returns: self Provides a fluent interface
| Parameter Name | Type | Description |
|---|---|---|
| $order | string|array|\Expression |
Returns: self Provides a fluent interface
{@inheritDoc}
| Parameter Name | Type | Description |
|---|---|---|
| $adapter | ||
| $statementContainer |
Returns: \StatementContainerInterface
| Parameter Name | Type | Description |
|---|---|---|
| $quantifier | string|\Expression | DISTINCT|ALL |
Returns: self Provides a fluent interface
| Parameter Name | Type | Description |
|---|---|---|
| $part | string |
Returns: self Provides a fluent interface
| Parameter Name | Type | Description |
|---|---|---|
| $specification | ||
| $index | ||
| $specification |
Returns: self Provides a fluent interface
| Parameter Name | Type | Description |
|---|---|---|
| $select | \Select |
Returns:
Create where clause
| Parameter Name | Type | Description |
|---|---|---|
| $predicate | \Where|\Closure|string|array|\Predicate\PredicateInterface | |
| $combination | string | One |
Returns: self Provides a fluent interface